UCSF

Parameters Provided:

name.synonym = Asc-2-O-phosphate; Asc2P cpd; Ascorbyl monophosphate; C6H9O9P; L-Ascorbic acid, 2-(dihydrogen phosphate); L-ascorbic acid 2-phosphate; LS-173991; ascorbate-2-phosphate; ascorbyl-2-monophosphate; ascorbyl-2-phosphate; magnesium-L-ascorbyl-2-phosphate
filter.purchasability = all
page.num = 1

Structural Results Found: (before additional filtering)

SQL Query Was

SELECT DISTINCT(ci.sub_id_fk) AS sub_id FROM catalog_item AS ci INNER JOIN catalog AS c ON ci.cat_id_fk=c.cat_id INNER JOIN synonym AS syn ON (ci.cat_id_fk=syn.cat_fk AND ci.supplier_code=syn.supplier_code) INNER JOIN field AS f ON syn.field_fk=f.field_id  WHERE c.free = 1 AND syn.synonym IS NOT NULL AND syn.synonym LIKE 'Asc-2-O-phosphate; Asc2P cpd; Ascorbyl monophosphate; C6H9O9P; L-Ascorbic acid, 2-(dihydrogen phosphate); L-ascorbic acid 2-phosphate; LS-173991; ascorbate-2-phosphate; ascorbyl-2-monophosphate; ascorbyl-2-phosphate; magnesium-L-ascorbyl-2-phosphate' AND f.ftype IN (3,7,11,12,14) AND ci.sub_id_fk IN (SELECT ci.sub_id_fk AS sub_id FROM catalog_item AS ci INNER JOIN catalog AS c ON ci.cat_id_fk=c.cat_id  WHERE c.free = 1   )    LIMIT 50

Permalink

//zinc12.docking.org/results/combination?name.synonym=Asc-2-O-phosphate%3B+Asc2P+cpd%3B+Ascorbyl+monophosphate%3B+C6H9O9P%3B+L-Ascorbic+acid%2C+2-%28dihydrogen+phosphate%29%3B+L-ascorbic+acid+2-phosphate%3B+LS-173991%3B+ascorbate-2-phosphate%3B+ascorbyl-2-monophosphate%3B+ascorbyl-2-phosphate%3B+magnesium-L-ascorbyl-2-phosphate&filter.purchasability=all

Embed Link to Results